CRM360° CustomerApi Documentation
Return to Odata Help Page

Customer - LoyaltyCard

LoyaltyCard entities

Required HTTP Headers

  • X-Crm360Api-Token
  • X-Crm360Api-CustomerName
  • X-Crm360Api-DatabaseAlias

Functions

Entity Properties

Name Type Is Mandatory
LoyaltyCardId Int32
LoyaltyCardCode String
ContactId Int32
LoyaltyCardCodeTypeId Int16
LoyaltyCardTypeId Int16
LoyaltyCardStateId Int16
FreeField1 String
FreeField2 String
FreeField3 String
FreeField4 String
FreeField5 String
FreeFieldDateTime1 DateTime
FreeFieldDateTime2 DateTime
FreeFieldDateTime3 DateTime
FreeFieldDateTime4 DateTime
FreeFieldDateTime5 DateTime
FreeFieldNumber1 Decimal
FreeFieldNumber2 Decimal
FreeFieldNumber3 Decimal
FreeFieldNumber4 Decimal
FreeFieldNumber5 Decimal
FreeFieldBoolean1 Boolean
FreeFieldBoolean2 Boolean
FreeFieldBoolean3 Boolean
FreeFieldBoolean4 Boolean
FreeFieldBoolean5 Boolean
BrandId Int32
ValidityStartDate DateTime
ValidityEndDate DateTime
DeletionFlag Boolean
StoreId Int32
AdvertiserCreationDate DateTime
SourceId Int16
Contact Contact
Brand Brand
LoyaltyCardType LoyaltyCardType
LoyaltyCardCodeType LoyaltyCardCodeType
LoyaltyCardState LoyaltyCardState
LoyaltyCardActions Collection of LoyaltyCardAction
LoyaltyPoints Collection of LoyaltyPoint
Store Store
PurchaseHeaders Collection of PurchaseHeader
Vouchers Collection of Voucher
Source Source

Actions

Action Name Method Parameters Description Return
SumLoyaltyPoint POST
  • column (String)
  • loyaltyPointTypeId (Int32)
  • loyaltyCardTypeId (Int32)
  • brandId (Int32)
 Compute Sum of chosen column of related LoyaltyPoint entities Decimal 
Example
https://customerapi.fts-crm360.com/data/LoyaltyCards(32)/SumLoyaltyPoint?column=Amount&loyaltyPointTypeId=1&loyaltyCardTypeId=2&brandId=1


HttpMethod : POST
                                                                                       

Informations : 
           - column = PointAmount | PointOriginalAmount | PointUsedAmount | PointExpiredAmount
            - loyaltyPointTypeId is optional
            - loyaltyCardTypeId is optional
            - brandId is optional

Examples

Select all LoyaltyCards
https://customerapi.fts-crm360.com/data/LoyaltyCards()


HttpMethod : GET
                                                                                       

Json Result : 

[
{
"LoyaltyCardId" : "30",
"LoyaltyCardCode" : "bAmMmQa",
"ContactId" : "80",
"LoyaltyCardCodeTypeId" : "9",
"LoyaltyCardTypeId" : "7",
"LoyaltyCardStateId" : "1",
"FreeField1" : "aykbQVxtA",
"FreeField2" : "Q4Xe0rO9EC21R",
"FreeField3" : "8H 1BG9 hIH",
"FreeField4" : "6pIAwjK3ws G vj",
"FreeField5" : "o  jg",
"FreeFieldDateTime1" : "1998-07-10T00:00:00",
"FreeFieldDateTime2" : "2009-01-22T00:00:00",
"FreeFieldDateTime3" : "1998-12-13T00:00:00",
"FreeFieldDateTime4" : "2005-01-01T00:00:00",
"FreeFieldDateTime5" : "2022-01-23T00:00:00",
"FreeFieldNumber1" : "7963434.276",
"FreeFieldNumber2" : "8133747.338",
"FreeFieldNumber3" : "4359457.628",
"FreeFieldNumber4" : "2178933.536",
"FreeFieldNumber5" : "7399267.282",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"BrandId" : "39",
"ValidityStartDate" : "2005-05-01T00:00:00",
"ValidityEndDate" : "2012-06-11T00:00:00",
"DeletionFlag" : "True",
"StoreId" : "84",
"AdvertiserCreationDate" : "2009-07-10T00:00:00",
"SourceId" : "8"
},
{
"LoyaltyCardId" : "95",
"LoyaltyCardCode" : "WbZaDM6rGJTjzwylr",
"ContactId" : "5",
"LoyaltyCardCodeTypeId" : "4",
"LoyaltyCardTypeId" : "9",
"LoyaltyCardStateId" : "2",
"FreeField1" : "Wf5tmeG9",
"FreeField2" : "BjWORtbDM",
"FreeField3" : "HWUExyHB3",
"FreeField4" : "5iboHE",
"FreeField5" : "fWlbkH R cgg2O9LrB",
"FreeFieldDateTime1" : "2020-06-18T00:00:00",
"FreeFieldDateTime2" : "1995-10-05T00:00:00",
"FreeFieldDateTime3" : "2007-07-04T00:00:00",
"FreeFieldDateTime4" : "1998-11-26T00:00:00",
"FreeFieldDateTime5" : "2022-04-02T00:00:00",
"FreeFieldNumber1" : "5428452.712",
"FreeFieldNumber2" : "8976852.588",
"FreeFieldNumber3" : "3651894.763",
"FreeFieldNumber4" : "1544214.348",
"FreeFieldNumber5" : "8743133.685",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "False",
"BrandId" : "85",
"ValidityStartDate" : "2021-09-21T00:00:00",
"ValidityEndDate" : "2000-11-17T00:00:00",
"DeletionFlag" : "False",
"StoreId" : "48",
"AdvertiserCreationDate" : "1998-08-11T00:00:00",
"SourceId" : "4"
},
...
]
            
                                                     

Select LoyaltyCard by Id
https://customerapi.fts-crm360.com/data/LoyaltyCards(30)


HttpMethod : GET
                                                                                       

Json Result : 

{
"LoyaltyCardId" : "10",
"LoyaltyCardCode" : "IWjSezL8E 4kMN9jq",
"ContactId" : "78",
"LoyaltyCardCodeTypeId" : "9",
"LoyaltyCardTypeId" : "1",
"LoyaltyCardStateId" : "6",
"FreeField1" : "0A QFJP6qgpj",
"FreeField2" : "ru9FCTr",
"FreeField3" : "nbApsNbzVc",
"FreeField4" : "mghcNsAt",
"FreeField5" : "UY5nCS0",
"FreeFieldDateTime1" : "2015-04-22T00:00:00",
"FreeFieldDateTime2" : "2015-02-16T00:00:00",
"FreeFieldDateTime3" : "2019-09-26T00:00:00",
"FreeFieldDateTime4" : "2018-06-18T00:00:00",
"FreeFieldDateTime5" : "2022-01-25T00:00:00",
"FreeFieldNumber1" : "1268649.823",
"FreeFieldNumber2" : "1746225.843",
"FreeFieldNumber3" : "9331116.962",
"FreeFieldNumber4" : "6623539.663",
"FreeFieldNumber5" : "1919333.526",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "True",
"BrandId" : "81",
"ValidityStartDate" : "2021-11-15T00:00:00",
"ValidityEndDate" : "2009-09-27T00:00:00",
"DeletionFlag" : "True",
"StoreId" : "60",
"AdvertiserCreationDate" : "2017-01-14T00:00:00",
"SourceId" : "9"
}
            
                                                     

Create a LoyaltyCard
https://customerapi.fts-crm360.com/data/LoyaltyCards()


HttpMethod : POST
                                                                                                

Json Post :
{
"LoyaltyCardCode" : "qaeBB1",
"ContactId" : "23",
"LoyaltyCardCodeTypeId" : "8",
"LoyaltyCardTypeId" : "3",
"LoyaltyCardStateId" : "1",
"FreeField1" : "DPSu1uJz",
"FreeField2" : "70GqWsYc7 iEuBU4vPb",
"FreeField3" : "UhcS3jm",
"FreeField4" : "12kLNC TzrUdw5Qd",
"FreeField5" : "VM90Fd",
"FreeFieldDateTime1" : "2015-10-16T00:00:00",
"FreeFieldDateTime2" : "2011-03-22T00:00:00",
"FreeFieldDateTime3" : "2011-05-04T00:00:00",
"FreeFieldDateTime4" : "2013-04-24T00:00:00",
"FreeFieldDateTime5" : "2003-11-23T00:00:00",
"FreeFieldNumber1" : "6452771.299",
"FreeFieldNumber2" : "5956962.864",
"FreeFieldNumber3" : "3925469.748",
"FreeFieldNumber4" : "6645642.271",
"FreeFieldNumber5" : "8253825.329",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "False",
"BrandId" : "67",
"ValidityStartDate" : "2001-02-24T00:00:00",
"ValidityEndDate" : "2022-03-30T00:00:00",
"DeletionFlag" : "False",
"StoreId" : "13",
"AdvertiserCreationDate" : "2017-06-15T00:00:00",
"SourceId" : "4"
}
            


Informations : 
 - Non mandatory fields are optional for Json Post
                                                     

Update a LoyaltyCard
https://customerapi.fts-crm360.com/data/LoyaltyCards(30)


HttpMethod : PUT
                                                                                                

Json Post :
{
"LoyaltyCardId" : "75",
"LoyaltyCardCode" : "Q1i96f",
"ContactId" : "35",
"LoyaltyCardCodeTypeId" : "9",
"LoyaltyCardTypeId" : "1",
"LoyaltyCardStateId" : "6",
"FreeField1" : "Id6uHKrkcS2vM",
"FreeField2" : "NRYkSdXa88p",
"FreeField3" : "TpjoqUo2LQMp",
"FreeField4" : "EwSyZGWd7RDifRFxB9w",
"FreeField5" : "qY53pLajmy7E",
"FreeFieldDateTime1" : "2016-02-20T00:00:00",
"FreeFieldDateTime2" : "2013-06-09T00:00:00",
"FreeFieldDateTime3" : "2001-07-02T00:00:00",
"FreeFieldDateTime4" : "2015-12-17T00:00:00",
"FreeFieldDateTime5" : "1997-03-24T00:00:00",
"FreeFieldNumber1" : "6683144.512",
"FreeFieldNumber2" : "1512342.378",
"FreeFieldNumber3" : "4227882.398",
"FreeFieldNumber4" : "8147449.261",
"FreeFieldNumber5" : "5461415.666",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "True",
"BrandId" : "51",
"ValidityStartDate" : "2005-03-08T00:00:00",
"ValidityEndDate" : "2000-03-17T00:00:00",
"DeletionFlag" : "True",
"StoreId" : "17",
"AdvertiserCreationDate" : "2001-03-09T00:00:00",
"SourceId" : "1"
}
            


Informations : 
 - Non mandatory fields are optional for Json Post
                                                     

Patch a LoyaltyCard
https://customerapi.fts-crm360.com/data/LoyaltyCards(30)


HttpMethod : PATCH
                                                                                                

Json Post :
{
"FreeField2" : "OS9JZv3gAnrT",
"FreeFieldDateTime5" : "1995-03-23T00:00:00",
"LoyaltyCardCode" : "MRxVfqWTghfB3",
"FreeFieldBoolean1" : "True",
"FreeField3" : "pezd4Vt 1G3wHfu0",
"FreeFieldBoolean2" : "True"
}
            


Informations : 
 - Non mandatory fields are optional for Json Post
                                                     

Delete a LoyaltyCard
https://customerapi.fts-crm360.com/data/LoyaltyCards(30)


HttpMethod : DELETE